package com.the4man.framework.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * Created by lenovo on 2017/12/11.
 */
public class MessageExample {
    private String empId;
    private int startRow = 0;
    private int pageSize = 0;
    protected String orderByClause;
    protected boolean distinct;
    protected List<Criteria> oredCriteria = new ArrayList();

    public int getStartRow() {
        return this.startRow;
    }

    public void setStartRow(int startRow) {
        this.startRow = startRow;
    }

    public int getPageSize() {
        return this.pageSize;
    }

    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    public String getEmpId() {
        return this.empId;
    }

    public void setEmpId(String empId) {
        this.empId = empId;
    }

    public MessageExample() {
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return this.orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return this.distinct;
    }

    public List<MessageExample.Criteria> getOredCriteria() {
        return this.oredCriteria;
    }

    public void or(MessageExample.Criteria criteria) {
        this.oredCriteria.add(criteria);
    }

    public MessageExample.Criteria or() {
        MessageExample.Criteria criteria = this.createCriteriaInternal();
        this.oredCriteria.add(criteria);
        return criteria;
    }

    public MessageExample.Criteria createCriteria() {
        MessageExample.Criteria criteria = this.createCriteriaInternal();
        if(this.oredCriteria.size() == 0) {
            this.oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected MessageExample.Criteria createCriteriaInternal() {
        MessageExample.Criteria criteria = new MessageExample.Criteria();
        return criteria;
    }

    public void clear() {
        this.oredCriteria.clear();
        this.orderByClause = null;
        this.distinct = false;
    }

    public static class Criteria extends MessageExample.GeneratedCriteria {
        protected Criteria() {
        }
    }

    public static class Criterion {
        private String condition;
        private Object value;
        private Object secondValue;
        private boolean noValue;
        private boolean singleValue;
        private boolean betweenValue;
        private boolean listValue;
        private String typeHandler;

        public String getCondition() {
            return this.condition;
        }

        public Object getValue() {
            return this.value;
        }

        public Object getSecondValue() {
            return this.secondValue;
        }

        public boolean isNoValue() {
            return this.noValue;
        }

        public boolean isSingleValue() {
            return this.singleValue;
        }

        public boolean isBetweenValue() {
            return this.betweenValue;
        }

        public boolean isListValue() {
            return this.listValue;
        }

        public String getTypeHandler() {
            return this.typeHandler;
        }

        protected Criterion(String condition) {
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if(value instanceof List) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }

        }

        protected Criterion(String condition, Object value) {
            this(condition, value, (String)null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, (String)null);
        }
    }

    protected abstract static class GeneratedCriteria {
        protected List<MessageExample.Criterion> criteria = new ArrayList();

        protected GeneratedCriteria() {
        }

        public boolean isValid() {
            return this.criteria.size() > 0;
        }

        public List<MessageExample.Criterion> getAllCriteria() {
            return this.criteria;
        }

        public List<MessageExample.Criterion> getCriteria() {
            return this.criteria;
        }

        protected void addCriterion(String condition) {
            if(condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            } else {
                this.criteria.add(new MessageExample.Criterion(condition));
            }
        }

        protected void addCriterion(String condition, Object value, String property) {
            if(value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            } else {
                this.criteria.add(new MessageExample.Criterion(condition, value));
            }
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if(value1 != null && value2 != null) {
                this.criteria.add(new MessageExample.Criterion(condition, value1, value2));
            } else {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
        }

        public MessageExample.Criteria andTitleContentOR(String value) {
            this.addCriterion("(MSG_TITLE like '" + value + "' OR MSG_CONTENT like '" + value + "')");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andNoOffDate() {
            this.addCriterion("(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(msg_Create_Time)) < (validity*60*60)");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andIsReadEqualTo(String value) {
            this.addCriterion("msg_id in (select msg_id from message_record where IS_READ = '" + value + "')");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andRecUserEq(String value) {
            this.addCriterion("msg_id in (select msg_id from message_record where REC_USER = '" + value + "')");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdIsNull() {
            this.addCriterion("MSG_ID is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdIsNotNull() {
            this.addCriterion("MSG_ID is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdEqualTo(String value) {
            this.addCriterion("MSG_ID =", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdNotEqualTo(String value) {
            this.addCriterion("MSG_ID <>", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdGreaterThan(String value) {
            this.addCriterion("MSG_ID >", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdGreaterThanOrEqualTo(String value) {
            this.addCriterion("MSG_ID >=", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdLessThan(String value) {
            this.addCriterion("MSG_ID <", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdLessThanOrEqualTo(String value) {
            this.addCriterion("MSG_ID <=", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdLike(String value) {
            this.addCriterion("MSG_ID like", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdNotLike(String value) {
            this.addCriterion("MSG_ID not like", value, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdIn(List<String> values) {
            this.addCriterion("MSG_ID in", values, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdNotIn(List<String> values) {
            this.addCriterion("MSG_ID not in", values, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdBetween(String value1, String value2) {
            this.addCriterion("MSG_ID between", value1, value2, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgIdNotBetween(String value1, String value2) {
            this.addCriterion("MSG_ID not between", value1, value2, "msgId");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserIsNull() {
            this.addCriterion("MSG_CREATE_USER is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserIsNotNull() {
            this.addCriterion("MSG_CREATE_USER is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserEqualTo(String value) {
            this.addCriterion("MSG_CREATE_USER =", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserNotEqualTo(String value) {
            this.addCriterion("MSG_CREATE_USER <>", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserGreaterThan(String value) {
            this.addCriterion("MSG_CREATE_USER >", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserGreaterThanOrEqualTo(String value) {
            this.addCriterion("MSG_CREATE_USER >=", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserLessThan(String value) {
            this.addCriterion("MSG_CREATE_USER <", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserLessThanOrEqualTo(String value) {
            this.addCriterion("MSG_CREATE_USER <=", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserLike(String value) {
            this.addCriterion("MSG_CREATE_USER like", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserNotLike(String value) {
            this.addCriterion("MSG_CREATE_USER not like", value, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserIn(List<String> values) {
            this.addCriterion("MSG_CREATE_USER in", values, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserNotIn(List<String> values) {
            this.addCriterion("MSG_CREATE_USER not in", values, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserBetween(String value1, String value2) {
            this.addCriterion("MSG_CREATE_USER between", value1, value2, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateUserNotBetween(String value1, String value2) {
            this.addCriterion("MSG_CREATE_USER not between", value1, value2, "msgCreateUser");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleIsNull() {
            this.addCriterion("MSG_TITLE is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleIsNotNull() {
            this.addCriterion("MSG_TITLE is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleEqualTo(String value) {
            this.addCriterion("MSG_TITLE =", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleNotEqualTo(String value) {
            this.addCriterion("MSG_TITLE <>", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleGreaterThan(String value) {
            this.addCriterion("MSG_TITLE >", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleGreaterThanOrEqualTo(String value) {
            this.addCriterion("MSG_TITLE >=", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleLessThan(String value) {
            this.addCriterion("MSG_TITLE <", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleLessThanOrEqualTo(String value) {
            this.addCriterion("MSG_TITLE <=", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleLike(String value) {
            this.addCriterion("MSG_TITLE like", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleNotLike(String value) {
            this.addCriterion("MSG_TITLE not like", value, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleIn(List<String> values) {
            this.addCriterion("MSG_TITLE in", values, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleNotIn(List<String> values) {
            this.addCriterion("MSG_TITLE not in", values, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleBetween(String value1, String value2) {
            this.addCriterion("MSG_TITLE between", value1, value2, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTitleNotBetween(String value1, String value2) {
            this.addCriterion("MSG_TITLE not between", value1, value2, "msgTitle");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentIsNull() {
            this.addCriterion("MSG_CONTENT is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentIsNotNull() {
            this.addCriterion("MSG_CONTENT is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentEqualTo(String value) {
            this.addCriterion("MSG_CONTENT =", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentNotEqualTo(String value) {
            this.addCriterion("MSG_CONTENT <>", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentGreaterThan(String value) {
            this.addCriterion("MSG_CONTENT >", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentGreaterThanOrEqualTo(String value) {
            this.addCriterion("MSG_CONTENT >=", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentLessThan(String value) {
            this.addCriterion("MSG_CONTENT <", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentLessThanOrEqualTo(String value) {
            this.addCriterion("MSG_CONTENT <=", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentLike(String value) {
            this.addCriterion("MSG_CONTENT like", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentNotLike(String value) {
            this.addCriterion("MSG_CONTENT not like", value, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentIn(List<String> values) {
            this.addCriterion("MSG_CONTENT in", values, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentNotIn(List<String> values) {
            this.addCriterion("MSG_CONTENT not in", values, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentBetween(String value1, String value2) {
            this.addCriterion("MSG_CONTENT between", value1, value2, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgContentNotBetween(String value1, String value2) {
            this.addCriterion("MSG_CONTENT not between", value1, value2, "msgContent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeIsNull() {
            this.addCriterion("MSG_CREATE_TIME is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeIsNotNull() {
            this.addCriterion("MSG_CREATE_TIME is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeEqualTo(Date value) {
            this.addCriterion("MSG_CREATE_TIME =", value, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeNotEqualTo(Date value) {
            this.addCriterion("MSG_CREATE_TIME <>", value, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeGreaterThan(Date value) {
            this.addCriterion("MSG_CREATE_TIME >", value, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeGreaterThanOrEqualTo(Date value) {
            this.addCriterion("MSG_CREATE_TIME >=", value, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeLessThan(Date value) {
            this.addCriterion("MSG_CREATE_TIME <", value, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeLessThanOrEqualTo(Date value) {
            this.addCriterion("MSG_CREATE_TIME <=", value, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeIn(List<Date> values) {
            this.addCriterion("MSG_CREATE_TIME in", values, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeNotIn(List<Date> values) {
            this.addCriterion("MSG_CREATE_TIME not in", values, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeBetween(String value1, String value2) {
            this.addCriterion("MSG_CREATE_TIME between", value1, value2, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgCreateTimeNotBetween(Date value1, Date value2) {
            this.addCriterion("MSG_CREATE_TIME not between", value1, value2, "msgCreateTime");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeIsNull() {
            this.addCriterion("MSG_TYPE is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeIsNotNull() {
            this.addCriterion("MSG_TYPE is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeEqualTo(String value) {
            this.addCriterion("MSG_TYPE =", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeNotEqualTo(String value) {
            this.addCriterion("MSG_TYPE <>", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeGreaterThan(String value) {
            this.addCriterion("MSG_TYPE >", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeGreaterThanOrEqualTo(String value) {
            this.addCriterion("MSG_TYPE >=", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeLessThan(String value) {
            this.addCriterion("MSG_TYPE <", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeLessThanOrEqualTo(String value) {
            this.addCriterion("MSG_TYPE <=", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeLike(String value) {
            this.addCriterion("MSG_TYPE like", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeNotLike(String value) {
            this.addCriterion("MSG_TYPE not like", value, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeIn(List<String> values) {
            this.addCriterion("MSG_TYPE in", values, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeNotIn(List<String> values) {
            this.addCriterion("MSG_TYPE not in", values, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeBetween(String value1, String value2) {
            this.addCriterion("MSG_TYPE between", value1, value2, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgTypeNotBetween(String value1, String value2) {
            this.addCriterion("MSG_TYPE not between", value1, value2, "msgType");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelIsNull() {
            this.addCriterion("MSG_LEVEL is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelIsNotNull() {
            this.addCriterion("MSG_LEVEL is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelEqualTo(String value) {
            this.addCriterion("MSG_LEVEL =", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelNotEqualTo(String value) {
            this.addCriterion("MSG_LEVEL <>", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelGreaterThan(String value) {
            this.addCriterion("MSG_LEVEL >", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelGreaterThanOrEqualTo(String value) {
            this.addCriterion("MSG_LEVEL >=", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelLessThan(String value) {
            this.addCriterion("MSG_LEVEL <", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelLessThanOrEqualTo(String value) {
            this.addCriterion("MSG_LEVEL <=", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelLike(String value) {
            this.addCriterion("MSG_LEVEL like", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelNotLike(String value) {
            this.addCriterion("MSG_LEVEL not like", value, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelIn(List<String> values) {
            this.addCriterion("MSG_LEVEL in", values, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelNotIn(List<String> values) {
            this.addCriterion("MSG_LEVEL not in", values, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelBetween(String value1, String value2) {
            this.addCriterion("MSG_LEVEL between", value1, value2, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andMsgLevelNotBetween(String value1, String value2) {
            this.addCriterion("MSG_LEVEL not between", value1, value2, "msgLevel");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityIsNull() {
            this.addCriterion("VALIDITY is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityIsNotNull() {
            this.addCriterion("VALIDITY is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityEqualTo(Integer value) {
            this.addCriterion("VALIDITY =", value, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityNotEqualTo(Integer value) {
            this.addCriterion("VALIDITY <>", value, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityGreaterThan(Integer value) {
            this.addCriterion("VALIDITY >", value, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityGreaterThanOrEqualTo(Integer value) {
            this.addCriterion("VALIDITY >=", value, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityLessThan(Integer value) {
            this.addCriterion("VALIDITY <", value, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityLessThanOrEqualTo(Integer value) {
            this.addCriterion("VALIDITY <=", value, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityIn(List<Integer> values) {
            this.addCriterion("VALIDITY in", values, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityNotIn(List<Integer> values) {
            this.addCriterion("VALIDITY not in", values, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityBetween(Integer value1, Integer value2) {
            this.addCriterion("VALIDITY between", value1, value2, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andValidityNotBetween(Integer value1, Integer value2) {
            this.addCriterion("VALIDITY not between", value1, value2, "validity");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentIsNull() {
            this.addCriterion("SILENT is null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentIsNotNull() {
            this.addCriterion("SILENT is not null");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentEqualTo(String value) {
            this.addCriterion("SILENT =", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentNotEqualTo(String value) {
            this.addCriterion("SILENT <>", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentGreaterThan(String value) {
            this.addCriterion("SILENT >", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentGreaterThanOrEqualTo(String value) {
            this.addCriterion("SILENT >=", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentLessThan(String value) {
            this.addCriterion("SILENT <", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentLessThanOrEqualTo(String value) {
            this.addCriterion("SILENT <=", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentLike(String value) {
            this.addCriterion("SILENT like", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentNotLike(String value) {
            this.addCriterion("SILENT not like", value, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentIn(List<String> values) {
            this.addCriterion("SILENT in", values, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentNotIn(List<String> values) {
            this.addCriterion("SILENT not in", values, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentBetween(String value1, String value2) {
            this.addCriterion("SILENT between", value1, value2, "silent");
            return (MessageExample.Criteria)this;
        }

        public MessageExample.Criteria andSilentNotBetween(String value1, String value2) {
            this.addCriterion("SILENT not between", value1, value2, "silent");
            return (MessageExample.Criteria)this;
        }
    }
}
